Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 2771159 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 38 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 232.6 MiB |
| Average record size in memory | 88.0 B |
Variable types
| Numeric | 11 |
|---|
| Dataset has 38 (< 0.1%) duplicate rows | Duplicates |
u is highly correlated with g and 8 other fields | High correlation |
g is highly correlated with u and 8 other fields | High correlation |
r is highly correlated with u and 8 other fields | High correlation |
i is highly correlated with u and 8 other fields | High correlation |
z is highly correlated with u and 8 other fields | High correlation |
uErr is highly correlated with u and 8 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 8 other fields | High correlation |
iErr is highly correlated with u and 8 other fields | High correlation |
zErr is highly correlated with u and 8 other fields | High correlation |
u is highly correlated with g and 2 other fields | High correlation |
g is highly correlated with u and 4 other fields | High correlation |
r is highly correlated with rErr | High correlation |
i is highly correlated with iErr | High correlation |
z is highly correlated with g and 2 other fields | High correlation |
uErr is highly correlated with u and 2 other fields | High correlation |
gErr is highly correlated with u and 4 other fields | High correlation |
rErr is highly correlated with r | High correlation |
iErr is highly correlated with i | High correlation |
zErr is highly correlated with g and 2 other fields | High correlation |
u is highly correlated with g and 4 other fields | High correlation |
g is highly correlated with u and 8 other fields | High correlation |
r is highly correlated with u and 7 other fields | High correlation |
i is highly correlated with g and 6 other fields | High correlation |
z is highly correlated with g and 6 other fields | High correlation |
uErr is highly correlated with u and 2 other fields | High correlation |
gErr is highly correlated with u and 8 other fields | High correlation |
rErr is highly correlated with u and 7 other fields | High correlation |
iErr is highly correlated with g and 6 other fields | High correlation |
zErr is highly correlated with g and 6 other fields | High correlation |
u is highly skewed (γ1 = -398.6854988) | Skewed |
g is highly skewed (γ1 = -424.5365597) | Skewed |
i is highly skewed (γ1 = -666.5307062) | Skewed |
z is highly skewed (γ1 = -476.0855038) | Skewed |
uErr is highly skewed (γ1 = -403.3646815) | Skewed |
gErr is highly skewed (γ1 = -429.7716532) | Skewed |
iErr is highly skewed (γ1 = -679.5562007) | Skewed |
zErr is highly skewed (γ1 = -480.4752825) | Skewed |
Reproduction
| Analysis started | 2022-02-27 19:50:53.897983 |
|---|---|
| Analysis finished | 2022-02-27 19:54:24.488465 |
| Duration | 3 minutes and 30.59 seconds |
| Software version | pandas-profiling v3.1.1 |
| Download configuration | config.json |
ID
Real number (ℝ≥0)
| Distinct | 2771121 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.237664767 × 1018 |
| Minimum | 1.23764588 × 1018 |
|---|---|
| Maximum | 1.237680531 × 1018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | 1.23764588 × 1018 |
|---|---|
| 5-th percentile | 1.237651538 × 1018 |
| Q1 | 1.237658613 × 1018 |
| median | 1.237663784 × 1018 |
| Q3 | 1.237668298 × 1018 |
| 95-th percentile | 1.237679541 × 1018 |
| Maximum | 1.237680531 × 1018 |
| Range | 3.465180558 × 1013 |
| Interquartile range (IQR) | 9.685164556 × 1012 |
Descriptive statistics
| Standard deviation | 8.395171953 × 1012 |
|---|---|
| Coefficient of variation (CV) | 6.783074202 × 10-6 |
| Kurtosis | -0.5908909818 |
| Mean | 1.237664767 × 1018 |
| Median Absolute Deviation (MAD) | 4.663256416 × 1012 |
| Skewness | 0.3696698272 |
| Sum | -3.735202359 × 1017 |
| Variance | 7.047891212 × 1025 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.237657072 × 1018 | 2 | < 0.1% |
| 1.237658612 × 1018 | 2 | < 0.1% |
| 1.23765707 × 1018 | 2 | < 0.1% |
| 1.237663239 × 1018 | 2 | < 0.1% |
| 1.237671765 × 1018 | 2 | < 0.1% |
| 1.237678663 × 1018 | 2 | < 0.1% |
| 1.237663783 × 1018 | 2 | < 0.1% |
| 1.23766533 × 1018 | 2 | < 0.1% |
| 1.237657858 × 1018 | 2 | < 0.1% |
| 1.237663783 × 1018 | 2 | < 0.1% |
| Other values (2771111) | 2771139 |
| Value | Count | Frequency (%) |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 | |
| 1.23764588 × 1018 | 1 |
| Value | Count | Frequency (%) |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 | |
| 1.237680531 × 1018 | 1 |
| Distinct | 862299 |
|---|---|
| Distinct (%) | 31.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.48569117 |
| Minimum | -9999 |
|---|---|
| Maximum | 33.45042 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 17 |
| Negative (%) | < 0.1% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 18.743918 |
| Q1 | 20.68278 |
| median | 22.81066 |
| Q3 | 24.18339 |
| 95-th percentile | 26.06422 |
| Maximum | 33.45042 |
| Range | 10032.45042 |
| Interquartile range (IQR) | 3.50061 |
Descriptive statistics
| Standard deviation | 24.92592762 |
|---|---|
| Coefficient of variation (CV) | 1.108523969 |
| Kurtosis | 160288.9449 |
| Mean | 22.48569117 |
| Median Absolute Deviation (MAD) | 1.62966 |
| Skewness | -398.6854988 |
| Sum | 62311425.46 |
| Variance | 621.3018678 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 24.63466 | 363 | < 0.1% |
| 24.63467 | 315 | < 0.1% |
| 24.63465 | 259 | < 0.1% |
| 24.63468 | 224 | < 0.1% |
| 24.63469 | 101 | < 0.1% |
| 24.6347 | 73 | < 0.1% |
| 24.63464 | 71 | < 0.1% |
| 24.63471 | 32 | < 0.1% |
| 24.63463 | 24 | < 0.1% |
| 24.63472 | 22 | < 0.1% |
| Other values (862289) | 2769675 |
| Value | Count | Frequency (%) |
| -9999 | 17 | |
| 7.918076 | 1 | < 0.1% |
| 9.866534 | 1 | < 0.1% |
| 9.941942 | 1 | < 0.1% |
| 10.17025 | 1 | < 0.1% |
| 10.22717 | 1 | < 0.1% |
| 10.48895 | 1 | < 0.1% |
| 10.54181 | 1 | < 0.1% |
| 11.0643 | 1 | < 0.1% |
| 11.21397 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 33.45042 | 1 | |
| 32.66663 | 1 | |
| 31.77132 | 1 | |
| 31.38664 | 1 | |
| 31.10792 | 1 | |
| 30.96 | 1 | |
| 30.81344 | 1 | |
| 30.77991 | 1 | |
| 30.77358 | 1 | |
| 30.76049 | 1 |
| Distinct | 771110 |
|---|---|
| Distinct (%) | 27.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.80203725 |
| Minimum | -9999 |
|---|---|
| Maximum | 33.72469 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15 |
| Negative (%) | < 0.1% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 17.24236 |
| Q1 | 18.79789 |
| median | 21.54917 |
| Q3 | 22.42595 |
| 95-th percentile | 23.56188 |
| Maximum | 33.72469 |
| Range | 10032.72469 |
| Interquartile range (IQR) | 3.62806 |
Descriptive statistics
| Standard deviation | 23.40800036 |
|---|---|
| Coefficient of variation (CV) | 1.125274418 |
| Kurtosis | 181720.1326 |
| Mean | 20.80203725 |
| Median Absolute Deviation (MAD) | 1.22679 |
| Skewness | -424.5365597 |
| Sum | 57645752.73 |
| Variance | 547.9344807 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25.11438 | 108 | < 0.1% |
| 25.11437 | 66 | < 0.1% |
| 25.11439 | 57 | < 0.1% |
| 25.1144 | 45 | < 0.1% |
| 22.2569 | 25 | < 0.1% |
| 22.14977 | 25 | < 0.1% |
| 22.03572 | 24 | < 0.1% |
| 22.23071 | 23 | < 0.1% |
| 22.19956 | 23 | < 0.1% |
| 22.11493 | 23 | < 0.1% |
| Other values (771100) | 2770740 |
| Value | Count | Frequency (%) |
| -9999 | 15 | |
| 7.466997 | 1 | < 0.1% |
| 9.897096 | 1 | < 0.1% |
| 10.24659 | 1 | < 0.1% |
| 10.32773 | 1 | < 0.1% |
| 10.40744 | 1 | < 0.1% |
| 10.53339 | 1 | < 0.1% |
| 10.64063 | 1 | < 0.1% |
| 10.75463 | 1 | < 0.1% |
| 11.10078 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 33.72469 | 1 | |
| 32.90944 | 1 | |
| 32.14997 | 1 | |
| 31.67036 | 1 | |
| 31.60224 | 1 | |
| 31.52315 | 1 | |
| 31.35417 | 1 | |
| 31.32736 | 1 | |
| 31.06618 | 1 | |
| 30.95307 | 1 |
| Distinct | 701820 |
|---|---|
| Distinct (%) | 25.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.52903535 |
| Minimum | 8.902843 |
|---|---|
| Maximum | 22.99995 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | 8.902843 |
|---|---|
| 5-th percentile | 16.4361 |
| Q1 | 17.74938 |
| median | 20.05903 |
| Q3 | 20.9397 |
| 95-th percentile | 22.10703 |
| Maximum | 22.99995 |
| Range | 14.097107 |
| Interquartile range (IQR) | 3.19032 |
Descriptive statistics
| Standard deviation | 1.868180367 |
|---|---|
| Coefficient of variation (CV) | 0.09566168188 |
| Kurtosis | -0.7443412122 |
| Mean | 19.52903535 |
| Median Absolute Deviation (MAD) | 1.34907 |
| Skewness | -0.4281030079 |
| Sum | 54118062.08 |
| Variance | 3.490097884 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20.5507 | 23 | < 0.1% |
| 20.29045 | 22 | < 0.1% |
| 20.52563 | 22 | < 0.1% |
| 20.50425 | 22 | < 0.1% |
| 20.63658 | 22 | < 0.1% |
| 20.78461 | 22 | < 0.1% |
| 20.44975 | 22 | < 0.1% |
| 20.43664 | 22 | < 0.1% |
| 20.61646 | 22 | < 0.1% |
| 20.71745 | 22 | < 0.1% |
| Other values (701810) | 2770938 |
| Value | Count | Frequency (%) |
| 8.902843 | 1 | |
| 9.474476 | 1 | |
| 9.501574 | 1 | |
| 9.848258 | 1 | |
| 9.903746 | 1 | |
| 9.920951 | 1 | |
| 10.04462 | 1 | |
| 10.07247 | 1 | |
| 10.10956 | 1 | |
| 10.13125 | 1 |
| Value | Count | Frequency (%) |
| 22.99995 | 1 | |
| 22.99994 | 1 | |
| 22.99993 | 2 | |
| 22.99991 | 1 | |
| 22.9999 | 1 | |
| 22.99981 | 2 | |
| 22.9998 | 1 | |
| 22.99973 | 1 | |
| 22.99971 | 1 | |
| 22.99968 | 1 |
| Distinct | 684993 |
|---|---|
| Distinct (%) | 24.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.77579059 |
| Minimum | -9999 |
|---|---|
| Maximum | 31.65274 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 6 |
| Negative (%) | < 0.1% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 16.02066 |
| Q1 | 17.31647 |
| median | 19.17877 |
| Q3 | 19.91381 |
| 95-th percentile | 21.405591 |
| Maximum | 31.65274 |
| Range | 10030.65274 |
| Interquartile range (IQR) | 2.59734 |
Descriptive statistics
| Standard deviation | 14.83638504 |
|---|---|
| Coefficient of variation (CV) | 0.7901869685 |
| Kurtosis | 450050.0913 |
| Mean | 18.77579059 |
| Median Absolute Deviation (MAD) | 1.14519 |
| Skewness | -666.5307062 |
| Sum | 52030701.06 |
| Variance | 220.1183212 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 24.3618 | 78 | < 0.1% |
| 24.36181 | 47 | < 0.1% |
| 19.74928 | 27 | < 0.1% |
| 19.523 | 26 | < 0.1% |
| 19.61283 | 26 | < 0.1% |
| 19.66745 | 26 | < 0.1% |
| 19.56573 | 25 | < 0.1% |
| 19.54819 | 25 | < 0.1% |
| 19.6445 | 25 | < 0.1% |
| 19.69037 | 25 | < 0.1% |
| Other values (684983) | 2770829 |
| Value | Count | Frequency (%) |
| -9999 | 6 | |
| 8.364965 | 1 | < 0.1% |
| 8.411285 | 1 | < 0.1% |
| 9.370869 | 1 | < 0.1% |
| 9.527082 | 1 | < 0.1% |
| 9.550007 | 1 | < 0.1% |
| 9.568777 | 1 | < 0.1% |
| 9.75404 | 1 | < 0.1% |
| 9.85052 | 1 | < 0.1% |
| 9.886005 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 31.65274 | 1 | |
| 31.23163 | 1 | |
| 31.14982 | 1 | |
| 31.07335 | 1 | |
| 30.84629 | 1 | |
| 30.83151 | 1 | |
| 30.71105 | 1 | |
| 30.65209 | 1 | |
| 30.57623 | 1 | |
| 30.49861 | 1 |
| Distinct | 683964 |
|---|---|
| Distinct (%) | 24.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.35172229 |
| Minimum | -9999 |
|---|---|
| Maximum | 30.01704 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 12 |
| Negative (%) | < 0.1% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 15.702359 |
| Q1 | 17.02602 |
| median | 18.72145 |
| Q3 | 19.44232 |
| 95-th percentile | 21.12194 |
| Maximum | 30.01704 |
| Range | 10029.01704 |
| Interquartile range (IQR) | 2.4163 |
Descriptive statistics
| Standard deviation | 20.91051379 |
|---|---|
| Coefficient of variation (CV) | 1.139430592 |
| Kurtosis | 228069.9466 |
| Mean | 18.35172229 |
| Median Absolute Deviation (MAD) | 1.01414 |
| Skewness | -476.0855038 |
| Sum | 50855540.38 |
| Variance | 437.2495869 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 22.8269 | 569 | < 0.1% |
| 22.82691 | 330 | < 0.1% |
| 22.82689 | 170 | < 0.1% |
| 22.82692 | 89 | < 0.1% |
| 22.82693 | 41 | < 0.1% |
| 22.82694 | 31 | < 0.1% |
| 19.17929 | 29 | < 0.1% |
| 19.25344 | 28 | < 0.1% |
| 19.21716 | 28 | < 0.1% |
| 19.15662 | 27 | < 0.1% |
| Other values (683954) | 2769817 |
| Value | Count | Frequency (%) |
| -9999 | 12 | |
| 6.485586 | 1 | < 0.1% |
| 6.972855 | 1 | < 0.1% |
| 7.140388 | 1 | < 0.1% |
| 7.281719 | 1 | < 0.1% |
| 9.563122 | 1 | < 0.1% |
| 9.673311 | 1 | < 0.1% |
| 9.759146 | 1 | < 0.1% |
| 9.771158 | 1 | < 0.1% |
| 9.971849 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 30.01704 | 1 | |
| 29.38374 | 1 | |
| 29.26314 | 1 | |
| 29.18374 | 1 | |
| 29.17408 | 1 | |
| 29.04169 | 1 | |
| 29.03935 | 1 | |
| 29.0194 | 1 | |
| 28.96626 | 1 | |
| 28.91793 | 1 |
| Distinct | 2426286 |
|---|---|
| Distinct (%) | 87.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6182142492 |
| Minimum | -9999 |
|---|---|
| Maximum | 68.59662 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 17 |
| Negative (%) | < 0.1% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 0.034035557 |
| Q1 | 0.1267441 |
| median | 0.5586334 |
| Q3 | 1.039912 |
| 95-th percentile | 1.7884133 |
| Maximum | 68.59662 |
| Range | 10067.59662 |
| Interquartile range (IQR) | 0.9131679 |
Descriptive statistics
| Standard deviation | 24.77498648 |
|---|---|
| Coefficient of variation (CV) | 40.07508161 |
| Kurtosis | 162802.3021 |
| Mean | 0.6182142492 |
| Median Absolute Deviation (MAD) | 0.447231 |
| Skewness | -403.3646815 |
| Sum | 1713169.98 |
| Variance | 613.7999553 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -9999 | 17 | < 0.1% |
| 1.20849 | 8 | < 0.1% |
| 1.136649 | 8 | < 0.1% |
| 1.069763 | 8 | < 0.1% |
| 1.018593 | 8 | < 0.1% |
| 1.040624 | 8 | < 0.1% |
| 1.151895 | 8 | < 0.1% |
| 1.176417 | 8 | < 0.1% |
| 1.160801 | 7 | < 0.1% |
| 1.240877 | 7 | < 0.1% |
| Other values (2426276) | 2771072 |
| Value | Count | Frequency (%) |
| -9999 | 17 | |
| 0.0001527219 | 1 | < 0.1% |
| 0.0002531087 | 1 | < 0.1% |
| 0.0005957853 | 1 | < 0.1% |
| 0.0006323291 | 1 | < 0.1% |
| 0.001352592 | 1 | < 0.1% |
| 0.001526264 | 1 | < 0.1% |
| 0.002129648 | 1 | < 0.1% |
| 0.002286536 | 1 | < 0.1% |
| 0.002411008 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 68.59662 | 1 | |
| 55.50948 | 1 | |
| 46.49884 | 1 | |
| 40.79873 | 1 | |
| 39.44621 | 1 | |
| 38.20195 | 1 | |
| 36.87848 | 1 | |
| 30.9955 | 1 | |
| 28.22746 | 1 | |
| 27.37109 | 1 |
| Distinct | 2400043 |
|---|---|
| Distinct (%) | 86.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08109698909 |
| Minimum | -9999 |
|---|---|
| Maximum | 41.14543 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 15 |
| Negative (%) | < 0.1% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 0.0055363294 |
| Q1 | 0.013174905 |
| median | 0.09019347 |
| Q3 | 0.17298095 |
| 95-th percentile | 0.4513975 |
| Maximum | 41.14543 |
| Range | 10040.14543 |
| Interquartile range (IQR) | 0.159806045 |
Descriptive statistics
| Standard deviation | 23.26435021 |
|---|---|
| Coefficient of variation (CV) | 286.8707023 |
| Kurtosis | 184714.2977 |
| Mean | 0.08109698909 |
| Median Absolute Deviation (MAD) | 0.07794734 |
| Skewness | -429.7716532 |
| Sum | 224732.6512 |
| Variance | 541.2299908 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -9999 | 15 | < 0.1% |
| 0.10794 | 7 | < 0.1% |
| 0.128186 | 7 | < 0.1% |
| 0.1490033 | 7 | < 0.1% |
| 0.1224872 | 7 | < 0.1% |
| 0.14268 | 7 | < 0.1% |
| 0.1148187 | 7 | < 0.1% |
| 0.115449 | 7 | < 0.1% |
| 0.1088042 | 7 | < 0.1% |
| 0.1223937 | 7 | < 0.1% |
| Other values (2400033) | 2771081 |
| Value | Count | Frequency (%) |
| -9999 | 15 | |
| 0.0002041792 | 1 | < 0.1% |
| 0.000344248 | 1 | < 0.1% |
| 0.0003744256 | 1 | < 0.1% |
| 0.0004111342 | 1 | < 0.1% |
| 0.0004521218 | 1 | < 0.1% |
| 0.0005116757 | 1 | < 0.1% |
| 0.0005221947 | 1 | < 0.1% |
| 0.0005407966 | 1 | < 0.1% |
| 0.000569647 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 41.14543 | 1 | |
| 40.80777 | 1 | |
| 27.87659 | 1 | |
| 25.20317 | 1 | |
| 18.66603 | 1 | |
| 16.81018 | 1 | |
| 14.3314 | 1 | |
| 13.89603 | 1 | |
| 13.56933 | 1 | |
| 12.59677 | 1 |
| Distinct | 2512735 |
|---|---|
| Distinct (%) | 90.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.05601125719 |
| Minimum | 0.0002880982 |
|---|---|
| Maximum | 14.52429 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | 0.0002880982 |
|---|---|
| 5-th percentile | 0.004357583 |
| Q1 | 0.008711278 |
| median | 0.03777241 |
| Q3 | 0.073950285 |
| 95-th percentile | 0.18078481 |
| Maximum | 14.52429 |
| Range | 14.5240019 |
| Interquartile range (IQR) | 0.065239007 |
Descriptive statistics
| Standard deviation | 0.06815645868 |
|---|---|
| Coefficient of variation (CV) | 1.21683501 |
| Kurtosis | 1299.621293 |
| Mean | 0.05601125719 |
| Median Absolute Deviation (MAD) | 0.029996825 |
| Skewness | 11.73242203 |
| Sum | 155216.0995 |
| Variance | 0.00464530286 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.1017352 | 6 | < 0.1% |
| 0.1579721 | 6 | < 0.1% |
| 0.1084829 | 6 | < 0.1% |
| 0.1031431 | 6 | < 0.1% |
| 0.1278086 | 6 | < 0.1% |
| 0.1030422 | 6 | < 0.1% |
| 0.1009113 | 6 | < 0.1% |
| 0.1029735 | 6 | < 0.1% |
| 0.1349871 | 6 | < 0.1% |
| 0.04695546 | 6 | < 0.1% |
| Other values (2512725) | 2771099 |
| Value | Count | Frequency (%) |
| 0.0002880982 | 1 | |
| 0.0002945296 | 1 | |
| 0.0003206228 | 1 | |
| 0.0003519821 | 1 | |
| 0.0003707175 | 1 | |
| 0.0003707407 | 1 | |
| 0.0003747093 | 1 | |
| 0.0003870378 | 1 | |
| 0.0004120384 | 1 | |
| 0.0004849193 | 1 |
| Value | Count | Frequency (%) |
| 14.52429 | 1 | |
| 9.04069 | 1 | |
| 8.556941 | 1 | |
| 8.420018 | 1 | |
| 7.712391 | 1 | |
| 7.497026 | 1 | |
| 7.276915 | 1 | |
| 5.528741 | 1 | |
| 5.501844 | 1 | |
| 5.124316 | 1 |
| Distinct | 2458989 |
|---|---|
| Distinct (%) | 88.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0190022825 |
| Minimum | -9999 |
|---|---|
| Maximum | 55.15096 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 6 |
| Negative (%) | < 0.1% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 0.0043685914 |
| Q1 | 0.008751204 |
| median | 0.02717291 |
| Q3 | 0.04588176 |
| 95-th percentile | 0.1377873 |
| Maximum | 55.15096 |
| Range | 10054.15096 |
| Interquartile range (IQR) | 0.037130556 |
Descriptive statistics
| Standard deviation | 14.71337641 |
|---|---|
| Coefficient of variation (CV) | 774.2952151 |
| Kurtosis | 461815.2536 |
| Mean | 0.0190022825 |
| Median Absolute Deviation (MAD) | 0.018490926 |
| Skewness | -679.5562007 |
| Sum | 52658.34617 |
| Variance | 216.4834455 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.0293873 | 7 | < 0.1% |
| 0.02603347 | 6 | < 0.1% |
| 0.01029926 | 6 | < 0.1% |
| 0.03017065 | 6 | < 0.1% |
| 0.02851547 | 6 | < 0.1% |
| 0.01049611 | 6 | < 0.1% |
| -9999 | 6 | < 0.1% |
| 0.0119009 | 6 | < 0.1% |
| 0.01132452 | 6 | < 0.1% |
| 0.03408777 | 6 | < 0.1% |
| Other values (2458979) | 2771098 |
| Value | Count | Frequency (%) |
| -9999 | 6 | |
| 4.2032 × 10-6 | 1 | < 0.1% |
| 0.0002416363 | 1 | < 0.1% |
| 0.0002654212 | 1 | < 0.1% |
| 0.0002655984 | 1 | < 0.1% |
| 0.0003338849 | 1 | < 0.1% |
| 0.0003575227 | 1 | < 0.1% |
| 0.0003629721 | 1 | < 0.1% |
| 0.0004060516 | 1 | < 0.1% |
| 0.0004348774 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 55.15096 | 1 | |
| 52.3215 | 1 | |
| 48.50616 | 1 | |
| 28.0332 | 1 | |
| 26.41502 | 1 | |
| 20.70949 | 1 | |
| 19.05205 | 1 | |
| 16.70047 | 1 | |
| 16.66532 | 1 | |
| 14.79383 | 1 |
| Distinct | 2398609 |
|---|---|
| Distinct (%) | 86.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.06009573046 |
| Minimum | -9999 |
|---|---|
| Maximum | 125.6025 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 12 |
| Negative (%) | < 0.1% |
| Memory size | 21.1 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | 0.0093093303 |
| Q1 | 0.022616205 |
| median | 0.06647062 |
| Q3 | 0.11302155 |
| 95-th percentile | 0.36526517 |
| Maximum | 125.6025 |
| Range | 10124.6025 |
| Interquartile range (IQR) | 0.090405345 |
Descriptive statistics
| Standard deviation | 20.80856889 |
|---|---|
| Coefficient of variation (CV) | 346.2570257 |
| Kurtosis | 230878.3021 |
| Mean | 0.06009573046 |
| Median Absolute Deviation (MAD) | 0.04462266 |
| Skewness | -480.4752825 |
| Sum | 166534.8243 |
| Variance | 432.9965392 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -9999 | 12 | < 0.1% |
| 0.1069008 | 9 | < 0.1% |
| 0.1196612 | 8 | < 0.1% |
| 0.10416 | 8 | < 0.1% |
| 0.104101 | 8 | < 0.1% |
| 0.1038319 | 8 | < 0.1% |
| 0.1070111 | 8 | < 0.1% |
| 0.1069292 | 8 | < 0.1% |
| 0.101817 | 8 | < 0.1% |
| 0.1187577 | 8 | < 0.1% |
| Other values (2398599) | 2771074 |
| Value | Count | Frequency (%) |
| -9999 | 12 | |
| 0.0001718631 | 1 | < 0.1% |
| 0.00020425 | 1 | < 0.1% |
| 0.0002246803 | 1 | < 0.1% |
| 0.0004583807 | 1 | < 0.1% |
| 0.0004735135 | 1 | < 0.1% |
| 0.0009759665 | 1 | < 0.1% |
| 0.001006559 | 1 | < 0.1% |
| 0.001018574 | 1 | < 0.1% |
| 0.001079047 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 125.6025 | 1 | |
| 70.74406 | 1 | |
| 51.20518 | 1 | |
| 48.38092 | 1 | |
| 43.06553 | 1 | |
| 38.72721 | 1 | |
| 35.62029 | 1 | |
| 33.70526 | 1 | |
| 28.62317 | 1 | |
| 28.58433 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1237671129125683920 | 24.70152 | 22.30560 | 21.74474 | 21.40080 | 21.42348 | 0.781686 | 0.098980 | 0.078220 | 0.082370 | 0.240668 |
| 1 | 1237657772314394978 | 22.67397 | 21.96686 | 21.94899 | 21.72379 | 21.86105 | 0.390818 | 0.077608 | 0.128782 | 0.172128 | 0.565489 |
| 2 | 1237660764832400503 | 26.18586 | 22.41516 | 21.65361 | 21.57355 | 21.89604 | 0.371185 | 0.111313 | 0.079666 | 0.103673 | 0.496207 |
| 3 | 1237665584334570546 | 24.60471 | 21.87256 | 21.65432 | 21.64291 | 22.18519 | 0.826998 | 0.060778 | 0.065266 | 0.100126 | 0.507707 |
| 4 | 1237657190904300059 | 25.12164 | 22.79996 | 22.21146 | 21.85425 | 22.10207 | 0.682036 | 0.133950 | 0.111180 | 0.112090 | 0.480457 |
| 5 | 1237663543144874769 | 24.09210 | 22.85346 | 22.30763 | 22.04790 | 22.40283 | 0.642321 | 0.129014 | 0.124250 | 0.135843 | 0.529423 |
| 6 | 1237680503433463381 | 23.98054 | 24.24618 | 22.73013 | 21.30288 | 19.85708 | 1.701148 | 0.932739 | 0.479780 | 0.194279 | 0.188464 |
| 7 | 1237668298210279496 | 24.17533 | 26.84352 | 20.13889 | 18.72636 | 21.07554 | 2.558426 | 0.675604 | 0.061569 | 0.060317 | 0.877250 |
| 8 | 1237657877000749920 | 21.80250 | 20.75988 | 20.21546 | 20.13754 | 20.19818 | 0.138595 | 0.031938 | 0.025508 | 0.032024 | 0.116473 |
| 9 | 1237668350284333541 | 25.30149 | 21.97474 | 21.25391 | 21.16108 | 21.16152 | 0.645250 | 0.078875 | 0.052745 | 0.067674 | 0.213721 |
Last rows
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2771149 | 1237680100240786188 | 23.05869 | 22.36168 | 21.53303 | 21.11670 | 20.31947 | 0.601664 | 0.136826 | 0.119876 | 0.113521 | 0.223924 |
| 2771150 | 1237662302978114005 | 21.71403 | 21.37239 | 20.93563 | 20.71536 | 20.44528 | 0.125691 | 0.041273 | 0.040624 | 0.046867 | 0.112831 |
| 2771151 | 1237658611977028500 | 24.82571 | 23.13886 | 21.54026 | 20.30895 | 19.37826 | 2.869478 | 0.584235 | 0.202527 | 0.099133 | 0.153437 |
| 2771152 | 1237665584327098663 | 19.93252 | 19.61594 | 19.43063 | 19.45920 | 19.33438 | 0.039515 | 0.013005 | 0.013562 | 0.019402 | 0.055167 |
| 2771153 | 1237678790817284224 | 20.07754 | 19.66287 | 19.60898 | 19.63647 | 20.09604 | 0.055920 | 0.014554 | 0.019643 | 0.027199 | 0.162892 |
| 2771154 | 1237669701051154669 | 21.69291 | 21.80268 | 21.37547 | 21.36539 | 21.50789 | 0.205582 | 0.091514 | 0.109365 | 0.164178 | 0.592550 |
| 2771155 | 1237651535483830513 | 21.12952 | 21.31596 | 21.49134 | 21.18736 | 20.98013 | 0.102443 | 0.056157 | 0.089118 | 0.101749 | 0.310130 |
| 2771156 | 1237680311229809450 | 22.07685 | 21.79657 | 21.48659 | 21.40146 | 20.84215 | 0.232213 | 0.056864 | 0.076320 | 0.100319 | 0.263959 |
| 2771157 | 1237661463836229952 | 21.26601 | 20.75931 | 20.57111 | 20.42262 | 20.52666 | 0.085725 | 0.024749 | 0.028326 | 0.033730 | 0.121159 |
| 2771158 | 1237649920043581852 | 22.59109 | 21.27139 | 20.82199 | 20.61607 | 20.61585 | 0.305951 | 0.048192 | 0.045708 | 0.055666 | 0.222432 |
Most frequently occurring
| ID | u | g | r | i | z | uErr | gErr | rErr | iErr | zErr | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1237649920046661771 | 18.92138 | 17.15256 | 16.11338 | 15.58986 | 15.17178 | 0.053663 | 0.006482 | 0.004357 | 0.004112 | 0.009762 | 2 |
| 1 | 1237653664718127323 | 20.03431 | 17.97154 | 16.85417 | 16.39723 | 15.94599 | 0.067821 | 0.007178 | 0.004625 | 0.004675 | 0.010448 | 2 |
| 2 | 1237655106771812489 | 19.90797 | 18.02617 | 17.01220 | 16.60744 | 16.26283 | 0.054020 | 0.007359 | 0.004823 | 0.004689 | 0.009639 | 2 |
| 3 | 1237655369831481388 | 18.87476 | 16.73923 | 15.59903 | 14.99624 | 14.48176 | 0.053057 | 0.004954 | 0.003337 | 0.003123 | 0.006469 | 2 |
| 4 | 1237655373577847178 | 17.28472 | 16.31550 | 15.81495 | 15.52917 | 15.28723 | 0.011611 | 0.003495 | 0.003124 | 0.003324 | 0.007057 | 2 |
| 5 | 1237657070088618230 | 23.04010 | 21.71487 | 21.54097 | 22.23682 | 22.60238 | 0.579544 | 0.078190 | 0.098634 | 0.260900 | 0.815591 | 2 |
| 6 | 1237657071698116685 | 18.36346 | 17.02286 | 16.59428 | 16.39064 | 16.24101 | 0.071954 | 0.012728 | 0.017125 | 0.021492 | 0.049975 | 2 |
| 7 | 1237657587096224096 | 19.95916 | 18.91797 | 18.44332 | 18.24111 | 18.08843 | 0.075555 | 0.017154 | 0.015753 | 0.029133 | 0.056606 | 2 |
| 8 | 1237657591393157322 | 17.85245 | 16.41396 | 15.85318 | 15.41643 | 15.11933 | 0.018482 | 0.003851 | 0.003545 | 0.004167 | 0.006736 | 2 |
| 9 | 1237657857680081097 | 19.12627 | 17.83440 | 17.08346 | 16.60760 | 16.30409 | 0.032253 | 0.006289 | 0.005009 | 0.005182 | 0.011097 | 2 |